SHERBERT RESEARCH

Author

Joseph H

1 Intoduction

Hello, I’m Joseph from Morocco.

Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.

I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.

Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.

This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.

2 About the project

The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.

The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.

Alt text Alt text Alt text Alt text

3 EDA

3.1 market research indestry’s yearly new recruit count

3.2 sherbert research’s workforce status over the years

4 Workforce sample

4.1 Abby Jones

Job title: Director
Associated: False
Socials: https://linkedin.com/in/abby-jones-3a400510 | https://twitter.com/peopletr

4.1.1 Abby Jones’s working period at sherbert research

4.1.2 Gantt plot of Abby Jones’s experience


4.2 Bay Clark

Job title: Director
Associated: False
Socials: https://linkedin.com/in/bay-clark-a3751923

4.2.1 Bay Clark’s working period at sherbert research

4.2.2 Gantt plot of Bay Clark’s experience


4.3 Bob Popumoff

Job title: Knee slapper
Associated: True
Socials: https://linkedin.com/in/bob-popumoff-16a42019a

4.3.1 Bob Popumoff’s working period at sherbert research

4.3.2 Gantt plot of Bob Popumoff’s experience


4.4 Danielle Moore

Job title: Graduate intern
Associated: False
Socials: https://linkedin.com/in/danielle-moore-a1049b80

4.4.1 Danielle Moore’s working period at sherbert research

4.4.2 Gantt plot of Danielle Moore’s experience


4.5 Danielle Morris

Job title: Research assistant
Associated: False
Socials: https://linkedin.com/in/morrisdanielle | https://angel.co/danielle-morris | https://twitter.com/danisaidthis | https://linkedin.com/in/danielle-morris-7474b322

4.5.1 Danielle Morris’s working period at sherbert research

4.5.2 Gantt plot of Danielle Morris’s experience


4.6 Danielle Rodi

Job title: Graduate intern
Associated: False
Socials: https://linkedin.com/in/danielle-rodi-a1049b80

4.6.1 Danielle Rodi’s working period at sherbert research

4.6.2 Gantt plot of Danielle Rodi’s experience


4.7 Emma Worrollo

Job title: Associate director
Associated: False
Socials: https://linkedin.com/in/emmaworrollo

4.7.1 Emma Worrollo’s working period at sherbert research

4.7.2 Gantt plot of Emma Worrollo’s experience


4.8 Eyal Efrat

Job title: Finance and operations director
Associated: True
Socials: https://linkedin.com/in/eyal-efrat-8783441a

4.8.1 Eyal Efrat’s working period at sherbert research

4.8.2 Gantt plot of Eyal Efrat’s experience


4.9 Gemma Wise

Job title: Junior research executive
Associated: True
Socials: https://linkedin.com/in/gemma-wise-56a29b159

4.9.1 Gemma Wise’s working period at sherbert research

4.9.2 Gantt plot of Gemma Wise’s experience


4.10 Herbert Sherbert

Job title: Marketing director
Associated: True
Socials: https://linkedin.com/in/herbert-sherbert-8b1aa517

4.10.1 Herbert Sherbert’s working period at sherbert research

4.10.2 Gantt plot of Herbert Sherbert’s experience


4.11 Ioanna Mentzou

Job title: Project manager
Associated: False
Socials: https://linkedin.com/in/ioanna-mentzou-83a438 | https://twitter.com/imentzos

4.11.1 Ioanna Mentzou’s working period at sherbert research

4.11.2 Gantt plot of Ioanna Mentzou’s experience


4.12 Jonathan Lichtenfeld

Job title: Intern
Associated: False
Socials: https://linkedin.com/in/jonathanlichtenfeld | https://facebook.com/jonathan.lichtenfeld.3 | https://linkedin.com/in/jonathan-lichtenfeld-22b844b6

4.12.1 Jonathan Lichtenfeld’s working period at sherbert research

4.12.2 Gantt plot of Jonathan Lichtenfeld’s experience


4.13 Lucy Seager

Job title: Work experience at children’s market research agency
Associated: False
Socials: https://linkedin.com/in/lucy-seager-90464443

4.13.1 Lucy Seager’s working period at sherbert research

4.13.2 Gantt plot of Lucy Seager’s experience


4.14 Marnie Freeman

Job title: Director
Associated: True
Socials: https://linkedin.com/in/marnie-freeman-7884635

4.14.1 Marnie Freeman’s working period at sherbert research

4.14.2 Gantt plot of Marnie Freeman’s experience


4.15 Nicki Karet

Job title: Managing director
Associated: True
Socials: https://linkedin.com/in/nicki-karet-3113445 | https://twitter.com/nicki_sherbert

4.15.1 Nicki Karet’s working period at sherbert research

4.15.2 Gantt plot of Nicki Karet’s experience


4.16 Sarah Mann

Job title: Project manager and research co-ordinator
Associated: False
Socials: https://linkedin.com/in/sarah-mann-6a41a914

4.16.1 Sarah Mann’s working period at sherbert research

4.16.2 Gantt plot of Sarah Mann’s experience